SUPPORT / SAMPLES & SAS NOTES
Problem Note 46510: Java exception occurs when importing CCVs after incremental data load
 |  |  |  |  |
In SAS® OpRisk VaR, after you perform an incremental data load and then attempt to import cross-classification variables (CCVs), you might get a Java exception error similar to the one shown below. In addition, any covariance matrix in the CCV fails to load. However, the CCV mappings continue to successfully load in spite of the error message.
To create a new CCV export file from the originally exported CCV that can be loaded without errors, see the code provided in the Full Code tab.
Example of Java Exception
SEVERE: Nov 17, 2011 2:50:40 PM: An error occurred when the process created
'Identity Mapping'.
java.sql.SQLException: Unable to execute update for an undetermined reason. SQL
passthru expression contained these errors:
at
com.sas.rio.MVALocalizedError.throwLocalizedException(MVALocalizedError.java:201
)
at com.sas.rio.MVAStatement.executeUpdate(MVAStatement.java:673)
at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.sas.oprisk.var3.sasutil.StatementProxy.invoke(StatementProxy.java:138)
at $Proxy3.executeUpdate(Unknown Source)
at
com.sas.oprisk.var3.core.folder.FolderManager.createFolder(FolderManager.java:10
56)
at
com.sas.oprisk.var3.sasutil.ExportImportUtilities.importCCVs(ExportImportUtiliti
es.java:953)
at
com.sas.oprisk.var3.ui.app.ImportCCVItemTask$1.run(ImportCCVItemTask.java:142)
at java.awt.event.InvocationEvent.dispatch(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$000(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.awt.EventQueue$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS OpRisk VaR | Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled HP-UX | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Linux on Itanium | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||